﻿CREATE TABLE [dbo].[Organisation](
	[OrgKey] [int] IDENTITY(1,1) NOT NULL,
	[OrgTS] [nvarchar](18) NULL,
	[Änderung] [datetime] NULL,
	[Prefix] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[ZusätzeFW] [nvarchar](50) NULL,
	[RechtsFKey] [int] NULL,
	[Suchbegriff] [nvarchar](50) NULL,
	[Abteilung] [nvarchar](50) NULL,
	[Adresse] [nvarchar](70) NULL,
	[EPLZ] [int] NULL,
	[Straße] [nvarchar](50) NULL,
	[TelNr1] [nvarchar](20) NULL,
	[TelNr2] [nvarchar](20) NULL,
	[FaxNr] [nvarchar](25) NULL,
	[e_Mail] [nvarchar](100) NULL,
	[Kurzwahlspeicher] [nvarchar](10) NULL,
	[KG] [bit] NULL,
	[MB] [bit] NULL,
	[TochterVon] [int] NULL,
	[Kreditlimit] [int] NULL,
	[Notiz] [nvarchar](max) NULL,
	[Export] [bit] NULL,
	[CreateOn] datetime2 not NULL default(sysdatetime()),
	[CreateBy] nvarchar(20) NULL,
	[LastChangedOn] datetime2 null,
	[LastChangedBy] nvarchar(20) null,
 CONSTRAINT [PK_Organisation] PRIMARY KEY CLUSTERED 
(
	[OrgKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


